Previous Topic

Next Topic

Querying User-Defined Tables

To build a business object for a user-defined table

You must build a business object for each new user-defined table you create; until you do, the table cannot be used as a source in a query definition.

  1. Create the user-defined table.
  2. Browse to the iMIS Framework Console.
  3. Select User Defined Tables and select Build All. The business object is built and prefaced with Cs (such as CsSurvey).
  4. If you need binary data types (Character field > 255 characters) to display in the field list, add each manually.

To add a binary field to the View list

When the business object is built, any Character-type fields with a length greater than 255 characters are converted to binary data type. Fields with binary data type do not display when you select All from the View list on the Display tab in IQA. You must manually add fields of this type to the list.

  1. Make sure you are in Advanced mode.
  2. On the Display tab, select All from the View list.
  3. Scroll to the bottom of the Display page.
  4. In the SQL Expression field, enter the name of the field.
  5. (Optional) Enter an Alias for the field.
  6. Select Add.

See Also

Integration with iMIS modules

Administering security for IQA integration with iMIS

To run a predefined query from Customers

To run a predefined query from Events

To run a predefined query from Orders

To run a predefined query from the Home page

Creating links to iMIS modules from query results

Creating a personalized query link on the Customers tab


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:15 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.